prepare("insert into invent_temporal(item_category,item_name,qty,measure,no_in_ms,totalpcs,unitcost,totalcost) values(:a,:b,:c,:d,:e,:f,:g,:h)") ; $query->bindparam(":a",$cat) ; $query->bindparam(":b",$iname) ; $query->bindparam(":c",$qty) ; $query->bindparam(":d",$ms) ; $query->bindparam(":e",$nip) ; $query->bindparam(":f",$tps) ; $query->bindparam(":g",$ucost) ; $query->bindparam(":h",$tcost) ; $query->execute() ; } if(isset($_POST['commit'])) { $ivid = inventid() ; $gettcost = $DBcon->prepare("select sum(totalcost) as tcost from invent_temporal") ; $gettcost->execute() ; $rwd = $gettcost->fetch(pdo::FETCH_ASSOC) ; $gc = $rwd['tcost'] ; $ins = $DBcon->prepare("insert into inventory_main(invent_id,gross_total,date_in,admin) values(:a,:b,NOW(),:c)") ; $ins->bindparam(":a",$ivid) ; $ins->bindparam(":b",$gc) ; $ins->bindparam(":c",$adm) ; if($ins->execute()) { $getall = $DBcon->prepare("select * from invent_temporal") ; $getall->execute() ; while($rd = $getall->fetch(pdo::FETCH_ASSOC)) { $comit = $DBcon->prepare("insert into invent_details(invent_id,item_category,item_name,qty,measure,totalpcs,nms,unit_cost,total_cost)values(:a,:b,:c,:d,:e,:f,:g,:h,:i)") ; $comit->bindparam(":a",$ivid) ; $comit->bindparam(":b",$rd['item_category']) ; $comit->bindparam(":c",$rd['item_name']) ; $comit->bindparam(":d",$rd['qty']) ; $comit->bindparam(":e",$rd['measure']) ; $comit->bindparam(":f",$rd['totalpcs']) ; $comit->bindparam(":g",$rd['no_in_ms']) ; $comit->bindparam(":h",$rd['unitcost']) ; $comit->bindparam(":i",$rd['totalcost']) ; if($comit->execute()) { $del = $DBcon->prepare("delete from invent_temporal") ; if($del->execute()) $mos = "INVENTORY COMMITED SUCCESSFUL TO DATABASE" ; } } } } ?> Inventory

Dashboard

ADDING INVENTORY

ITEM CATEGORY ITEM NAME MEASURE NO IN PACK
QUANTITY TOTAL PCS UNIT COST
     
       

PREVIEW

prepare("select * from invent_temporal") ; $gtd->execute() ; $ct = 0 ; while($grow = $gtd->fetch(pdo::FETCH_ASSOC)) { $ct++ ; ?>
SN CATEGORY ITEMNAME MEASURE QUANTITY NIP TOTAL PCS UNIT COST TOTALCOST ACTION
DELETE